package com.wmh.baseservice.operationaid.entity;

import com.baomidou.mybatisplus.annotation.*;
import lombok.Data;
import lombok.experimental.Accessors;

import java.io.Serializable;
import java.math.BigDecimal;
import java.time.LocalDateTime;

/**
 * 运营助手-竞品数据表
 * @author 谢骏
 * @TableName operation_aid_competitor_product
 * @createDate 2023-08-24 11:15:01
 */
@Data
@Accessors(chain = true)
@TableName("operation_aid_competitor_product")
public class CompetitorProduct implements Serializable {

    /**
     * 主键
     */
    @TableId(value = COL_ID ,type = IdType.AUTO)
    private Long id;

    /**
     * 数据周期
     */
    @TableField(value = COL_DATA_CYCLE)
    private String dataCycle;

    /**
     * 新品文本
     */
    @TableField(value = COL_NEW_TEXT)
    private String newText;

    /**
     * 类目
     */
    @TableField(value = COL_CATEGORY)
    private String category;

    /**
     * 来源平台
     */
    @TableField(value = COL_PLATFORM)
    private String platform;

    /**
     * 商品标题
     */
    @TableField(value = COL_PRODUCT_TITLE)
    private String productTitle;

    /**
     * 商品链接
     */
    @TableField(value = COL_PRODUCT_LINK)
    private String productLink;

    /**
     * 商品编号 
     */
    @TableField(value = COL_PRODUCT_ID)
    private Long productId;

    /**
     * 店铺名称
     */
    @TableField(value = COL_STORE_NAME)
    private String storeName;

    /**
     * 店铺编号
     */
    @TableField(value = COL_STORE_ID)
    private Long storeId;

    /**
     * 交易金额
     */
    @TableField(value = COL_TRANSACTION_AMOUNT)
    private BigDecimal transactionAmount;

    /**
     * 交易增长幅度(百分比)
     */
    @TableField(value = COL_TRANSACTION_GROWTH_RATE)
    private BigDecimal transactionGrowthRate;

    /**
     * 访客人数
     */
    @TableField(value = COL_VISITORS_NUM)
    private Integer visitorsNum;

    /**
     * 搜索人数
     */
    @TableField(value = COL_SEARCH_NUM)
    private Integer searchNum;

    /**
     * 收藏人数
     */
    @TableField(value = COL_COLLECT_NUM)
    private Integer collectNum;

    /**
     * 加购人数
     */
    @TableField(value = COL_BACK_BUY_NUM)
    private Integer backBuyNum;

    /**
     * 支付转化率(百分比)
     */
    @TableField(value = COL_PAY_TRANSFORM_RATE)
    private BigDecimal payTransformRate;

    /**
     * 支付人数
     */
    @TableField(value = COL_PAY_NUM)
    private Integer payNum;

    /**
     * 客单价
     */
    @TableField(value = COL_UNIT_PRICE)
    private BigDecimal unitPrice;

    /**
     * uv价值
     */
    @TableField(value = COL_UV_VALUE)
    private BigDecimal uvValue;

    /**
     * 搜索占比(百分比)
     */
    @TableField(value = COL_SEARCH_PROPORTION)
    private BigDecimal searchProportion;

    /**
     * 收藏率(百分比)
     */
    @TableField(value = COL_COLLECT_RATE)
    private BigDecimal collectRate;

    /**
     * 加购率(百分比)
     */
    @TableField(value = COL_BACK_BUY_RATE)
    private String backBuyRate;

    /**
     * 创建时间
     */
    @TableField(value = COL_CREATE_TIME)
    private LocalDateTime createTime;

    /**
     * 更新时间
     */
    @TableField(value = COL_UPDATE_TIME)
    private LocalDateTime updateTime;

    /**
     * 逻辑删除 0 未删除,1已删除
     */
    @TableField(value = COL_DELETED)
    @TableLogic
    private Integer deleted;


    /**
     * 主键
     */
    public static final String COL_ID = "id";

    /**
     * 数据周期
     */
    public static final String COL_DATA_CYCLE = "data_cycle";

    /**
     * 新品文本
     */
    public static final String COL_NEW_TEXT = "new_text";

    /**
     * 类目
     */
    public static final String COL_CATEGORY = "category";

    /**
     * 来源平台
     */
    public static final String COL_PLATFORM = "platform";

    /**
     * 商品标题
     */
    public static final String COL_PRODUCT_TITLE = "product_title";

    /**
     * 商品链接
     */
    public static final String COL_PRODUCT_LINK = "product_link";

    /**
     * 商品编号 
     */
    public static final String COL_PRODUCT_ID = "product_Id";

    /**
     * 店铺名称
     */
    public static final String COL_STORE_NAME = "store_name";

    /**
     * 店铺编号
     */
    public static final String COL_STORE_ID = "store_id";

    /**
     * 交易金额
     */
    public static final String COL_TRANSACTION_AMOUNT = "transaction_amount";

    /**
     * 交易增长服务(百分比)
     */
    public static final String COL_TRANSACTION_GROWTH_RATE = "transaction_growth_rate";

    /**
     * 访客人数
     */
    public static final String COL_VISITORS_NUM = "visitors_num";

    /**
     * 搜索人数
     */
    public static final String COL_SEARCH_NUM = "search_num";

    /**
     * 收藏人数
     */
    public static final String COL_COLLECT_NUM = "collect_num";

    /**
     * 加购人数
     */
    public static final String COL_BACK_BUY_NUM = "back_buy_num";

    /**
     * 支付转化率(百分比)
     */
    public static final String COL_PAY_TRANSFORM_RATE = "pay_transform_rate";

    /**
     * 支付人数
     */
    public static final String COL_PAY_NUM = "pay_num";

    /**
     * 客单价
     */
    public static final String COL_UNIT_PRICE = "unit_price";

    /**
     * uv价值
     */
    public static final String COL_UV_VALUE = "uv_value";

    /**
     * 搜索占比(百分比)
     */
    public static final String COL_SEARCH_PROPORTION = "search_proportion";

    /**
     * 收藏率(百分比)
     */
    public static final String COL_COLLECT_RATE = "collect_rate";

    /**
     * 加购率(百分比)
     */
    public static final String COL_BACK_BUY_RATE = "back_buy_rate";

    /**
     * 创建时间
     */
    public static final String COL_CREATE_TIME = "create_time";

    /**
     * 更新时间
     */
    public static final String COL_UPDATE_TIME = "update_time";

    /**
     * 逻辑删除 0 未删除,1已删除
     */
    public static final String COL_DELETED = "deleted";

    @TableField(exist = false)
    static final long serialVersionUID = 1L;
}
